select * from products where pro_name like '%quinceanera%bra%' or pro_des like '%quinceanera%bra%'union all select * from products where (pro_name like '%quinceanera%' or pro_des like '%quinceanera%') or(pro_name like '%bra%' or pro_des like '%bra%') and (pro_name not like '%quinceanera%bra%' or pro_des not like '%quinceanera%bra%')
Zebra Print Sash Pick ups Ruffles Colorful Sweet Sixteen Dresses
Pick ups Ruffles Accent Zebra Print Colorful Sweet Sixteen Dress
Ruffled Zebra Print Sweet Sixteen Dresses in Lavender and Black
Zebra Print Colorful Sweet Sixteen Dresses with Pick ups Beading
Bright Yellow Strapless Court Train Ruffles Sweet Sixteen Dress Giulias dress
Flowery Ruched One Shoulder Organza Sweet 15 Dress in Lilac
Laura Linney Teal and Green Ball Gown Sweet 15 Dresses with Ruffles Appliques
White Asymmetrical Taffeta Sweet 15 Dresses with Beading Flowers
Beaded and Ruched Orange and Black Quinceanera Gowns with Ruffles
Appliqued Watermelon and White Quinceanera Gowns with Pick ups
Fuchsia Sweetheart Quinceanera Dress with Ruffled Layers Appliques
Appliqued and Ruffled Organza Quinceanera Dress in Spring Green
Purple Taffeta Quinceanera Dress with Pick ups and Appliques 2013
Beaded White Quinceanera Gown Dresses with Red Frills and Appliques
Zebra Print Colorful One Shoulder Ruffled Quinceanera Gown Dress
Ruffled Spring Green Quinceanera Gown Dresses with Beading and Bow
2013 Popular Colorful Quinceanera Gown with Flowers and Ruffles
Green and White Organza Quinces Dresses with Appliques Pick ups
Red and White Sweetheart Appliques Decorate Quinceanera Dresses
Pink and Black Quinceanera Dress in Organza and Zebra Print Fabric
Sweetheart Burgundy Quinceanera Dress with Pick-ups and Appliques
Hot Pink Organza Strapless Sweet 16 Dress with Beading and Ruffles
Multi-color Organza Quinceanera Dress with Appliques and Ruffles
Taffeta Coral Red Sweet 15 Dress with Pick-ups and Hand Made Flowers
Sweetheart Blue Taffeta Quinceanera Gown with Appliques and Pick-ups
Beaded Fuchsia Quinceanera Dress With Zebra Print Fabric and Ruffles
Purple One Shoulder Quinceanera Gown with Ruffles Hand Made Flowers
White Strapless Quinceanera Dress with Pink Embroidery and Beading
Beaded Sweetheart Light Yellow Quinceanera Dress in Tulle and Organza
Sweetheart Light Yellow Quinceanera Dress in Tulle and Printed Fabric